Use Database::addQuotes in Special:WantedPages/UnwatchedPages
[lhc/web/wiklou.git] / includes / specials / SpecialUnwatchedpages.php
1 <?php
2 /**
3 * Implements Special:Unwatchedpages
4 *
5 * Copyright © 2005 Ævar Arnfjörð Bjarmason
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 2 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License along
18 * with this program; if not, write to the Free Software Foundation, Inc.,
19 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20 * http://www.gnu.org/copyleft/gpl.html
21 *
22 * @file
23 * @ingroup SpecialPage
24 * @author Ævar Arnfjörð Bjarmason <avarab@gmail.com>
25 */
26
27 /**
28 * A special page that displays a list of pages that are not on anyones watchlist.
29 *
30 * @ingroup SpecialPage
31 */
32 class UnwatchedpagesPage extends QueryPage {
33
34 function __construct( $name = 'Unwatchedpages' ) {
35 parent::__construct( $name, 'unwatchedpages' );
36 }
37
38 public function isExpensive() {
39 return true;
40 }
41
42 function isSyndicated() {
43 return false;
44 }
45
46 public function getQueryInfo() {
47 $dbr = wfGetDB( DB_REPLICA );
48 return [
49 'tables' => [ 'page', 'watchlist' ],
50 'fields' => [
51 'namespace' => 'page_namespace',
52 'title' => 'page_title',
53 'value' => 'page_namespace'
54 ],
55 'conds' => [
56 'wl_title IS NULL',
57 'page_is_redirect' => 0,
58 'page_namespace != ' . $dbr->addQuotes( NS_MEDIAWIKI ),
59 ],
60 'join_conds' => [ 'watchlist' => [
61 'LEFT JOIN', [ 'wl_title = page_title',
62 'wl_namespace = page_namespace' ] ] ]
63 ];
64 }
65
66 function sortDescending() {
67 return false;
68 }
69
70 function getOrderFields() {
71 return [ 'page_namespace', 'page_title' ];
72 }
73
74 /**
75 * Add the JS
76 * @param string|null $par
77 */
78 public function execute( $par ) {
79 parent::execute( $par );
80 $this->getOutput()->addModules( 'mediawiki.special.unwatchedPages' );
81 }
82
83 /**
84 * @param Skin $skin
85 * @param object $result Result row
86 * @return string
87 */
88 function formatResult( $skin, $result ) {
89 global $wgContLang;
90
91 $nt = Title::makeTitleSafe( $result->namespace, $result->title );
92 if ( !$nt ) {
93 return Html::element( 'span', [ 'class' => 'mw-invalidtitle' ],
94 Linker::getInvalidTitleDescription( $this->getContext(), $result->namespace, $result->title ) );
95 }
96
97 $text = $wgContLang->convert( $nt->getPrefixedText() );
98
99 $plink = Linker::linkKnown( $nt, htmlspecialchars( $text ) );
100 $wlink = Linker::linkKnown(
101 $nt,
102 $this->msg( 'watch' )->escaped(),
103 [ 'class' => 'mw-watch-link' ],
104 [ 'action' => 'watch' ]
105 );
106
107 return $this->getLanguage()->specialList( $plink, $wlink );
108 }
109
110 protected function getGroupName() {
111 return 'maintenance';
112 }
113 }